﻿CREATE PROCEDURE [dbo].[sp_Get_DivisionAdminWithLeads]

AS
	SELECT da.DivisionNum, da.Email from dbo.Leads l inner join [dbo].[DivisionAdmin] da on l.Division = da.DivisionNum
	where l.MdNumber = 'UKNW' group by da.DivisionNum, da.Email